EMT Practice Test

1. Question Content...

---

Question1: Which system schema contains the information about Time data and Schema Mapping?

Question2: What are the elements of ABAP Database Integration? There are 3 correct answers to this question.

Question3: What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question.

Question4: When are referential joins executed in analytical views? Choose the correct answer

Question5: Which conditional expressions can be used in Core Data Services (CDS) views? 2 ans

Question6: You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SOJD). Which SELECT statement would you use in the definition? Please choose the correct answer.

Question7: What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? There are 2 correct answers to this question

Question8: Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? There are 3 correct answers to this question.

Question9: What should you do to follow the code-to-data approach to programming? 2 ans

Question10: What output does the SAP HANA provide as a unique combination of hardware and software innovations? Please choose the correct answer.

Question11: You follow the Code-to-Data paradigm in your ABAP coding.
Which of the following scenarios conflicts with the SQL performance guideline "Keep unnecessary load away from the database"?

Question12: What all are the steps to perform -To enable type-ahead for an input field on a screen? There are 3 correct answers to this question.

Question13: What can you include in the projection list of a Core Data Services (CDS) view? 3 ans

Question14: Which statement is true for SAP HANA?

Question15: What are the features associated with ABAP CDS? There are 3 correct answers to this question.

Question16: Explain the Enterprise Information System of- SAP HANA Implementation Scenarios? There are 3 correct answers to this question

Question17: Which is not a Golden Rule for Open SQL? Please choose the correct answer.

Question18: Explain the Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question

Question19: What is the system privilege required to drop analytic privilege?

Question20: Which of the following is latest release of SAP HANA?

Question21: HANA modeling views can be created under

Question22: Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question.

Question23: Which character is used to escape host variables in the new Open SQL syntax?

Question24: What are the two types of editors available in ADT? There are 2 correct answers to this question.

Question25: Which feature can you use to improve the performance of data transformation in the Extract, Transform and Load (ETL) process?

Question26: In ADT which setting below to a specific project rather than the entire workbench. Choose the correct answer

Question27: Which option in SAP NetWeaver Gateway Service Builder (transaction SEGW) can be used to implement the consumption of a Core Data Services view?

Question28: Which of the following is true?

Question29: Which is better from performance point of view?

Question30: What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question.

Question31: What is the language SAP HANA is developed in?

Question32: Which system schema contains the column views of activated objects?

Question33: What views will be most efficient for General Modeling Principles? There are 2 correct answers to this question

Question34: Which of the following are classes of the ABAP Database Connectivity (ADBC) API? 2 ans

Question35: Which of the following can be part of an analytic view? (3 answers)

Question36: You changed an SAP HANA object that you transported using an SAP HANA Transport container. You want to release the transport request with your changes. In which sequence do you perform activities in the ABAP development system immediately before the release? Please choose the correct answer.

Question37: Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question.

Question38: You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer.

Question39: Which of the following ABAP language elements are mandatory for the implementation of a method as an ABAP Managed Database Procedure? 3 ans

Question40: You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node. This is the data that goes into the aggregation node:

Question41: You execute a Native SQL query statement to retrieve a list of information using the corresponding ABAP Database Connectivity (ADBC) API method.
Which additional steps are necessary to retrieve the result set into an internal table? 2 ans

Question42: Which engine is used to execute Analytic View?

Question43: What is the scope of the AbapCatalog.Buffering annotation in a Core Data Services (CDS) view?

Question44: AM DP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? There are 3 correct answers to this question.

Question45: In a Graphical calculation view you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS. How can you achieve this in a union node? There are 2 correct answers to this question.

Question46: You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? (3 right answers)

Question47: Which recent software innovations are applied in SAP HANA? 3 ans

Question48: In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog? Which of the following table types fulfill this requirement? Please choose the correct answer.

Question49: What are the two different kinds of Identifiers used to represent names used in SQL statement? There are 2 correct answers to this question

Question50: What are the key points that should be kept in mind while performing the Non-automatic update in SAP HANATr.Cont.? There are 2 correct answers to this question.

Question51: Discuss the main capabilities of SAP BusinessObjects Analysis for Office? There are 2 correct answers to this question

Question52: What are the features associated with ABAP CDS? (3 Ans) There are 3 correct answers to this question.

Question53: You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA.
Which type of database procedures can be called in this SQLScript procedure? Please choose the correct answer.

Question54: List down the three main concepts of the SAP HANA database There are 3 correct answers to this question

Question55: Which SAP HANA engine executes Calculation view? (2 answers)

Question56: According to the performance analysis recommendations; which steps are recommended after doing a database migration to SAP HANA?

Question57: What is the main advantage of SQLScript? (2 answers)

Question58: What you must do when you define and implement an ABAP Managed Database Procedure AMDP? (3 ans) There are 3 correct answers to this question.

Question59: You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias?
There are 3 correct answers to this question.

Question60: Why is not a key factor of ALV for HAN A? Please choose the correct answer.

Question61: How can you enhance an existing ABAP Search Help with a type-ahead function?

Question62: What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? There are 3 correct answers to this question.

Question63: What allows you to resolve errors quickly or warnings reported about the code? Please choose the correct answer.